﻿/*

--调用存储过程

USE [DataD_qianjian]
GO

DECLARE	@OutPutResult bit

EXEC	[dbo].[InventoryDeduction]
		@NutBatchCode='$P000000001010900638$V0018000040$L25031901$Q500$O4500125969$S80$E$N64',
		@DustCoverBatchCode='$P000000001010900100$V0018000040$L25031100$Q300$O4500125969$S80$E$N64',
		@ComponentBatchCode='$P000000001010900200$V0018000040$L25031200$Q500$O4500125969$S80$E$N64',
		@OutPutResult = @OutPutResult OUTPUT

SELECT	@OutPutResult as N'@OutPutResult'

GO

*/

select * from DataD_qianjian.dbo.QOP010StationResult

select * from DataD_qianjian.dbo.Inventory a where a.Qty != a.SurplusQty 
--where MainBatchCode = '$P000000001010900638$V0018000040$L25031901$Q500$O4500125969$S80$E$N64'
--and MaterialType = 1
--and SurplusQty > 0



